load data
truncate                                       
into table CRST_PO_APPROVED_SUPPLIER_LIST
fields terminated by '	'                    
trailing nullcols 
(     ASL_ID ,
	   USING_ORGANIZATION_ID ,
	   OWNING_ORGANIZATION_ID ,
	   VENDOR_BUSINESS_TYPE ,
	   ASL_STATUS_ID ,
	   LAST_UPDATE_DATE  	Date "YYYYMMDD HH24:MI:SS",
	   LAST_UPDATED_BY ,
	   CREATION_DATE     	Date "YYYYMMDD HH24:MI:SS",
	   CREATED_BY ,
	   MANUFACTURER_ID ,
	   VENDOR_ID ,
	   ITEM_ID ,
	   CATEGORY_ID ,
	   VENDOR_SITE_ID ,
	   PRIMARY_VENDOR_ITEM ,
	   MANUFACTURER_ASL_ID ,
	   REVIEW_BY_DATE  		Date "YYYYMMDD HH24:MI:SS",
	   COMMENTS ,              
	   ATTRIBUTE_CATEGORY ,          
	   ATTRIBUTE1 ,          
	   ATTRIBUTE2 ,                              
	   ATTRIBUTE3 ,                  
	   ATTRIBUTE4 ,                  
	   ATTRIBUTE5 ,                  
	   ATTRIBUTE6 ,                  
	   ATTRIBUTE7 ,                  
	   ATTRIBUTE8 ,                  
	   ATTRIBUTE9 ,                  
	   ATTRIBUTE10 ,                  
	   ATTRIBUTE11 ,                 
	   ATTRIBUTE12 ,                 
	   ATTRIBUTE13 ,                 
	   ATTRIBUTE14 ,                 
	   ATTRIBUTE15 ,                 
	   LAST_UPDATE_LOGIN ,
	   REQUEST_ID ,
	   PROGRAM_APPLICATION_ID ,
	   PROGRAM_ID ,
	   PROGRAM_UPDATE_DATE 	Date "YYYYMMDD HH24:MI:SS",
	   DISABLE_FLAG
)